Configuring ARI database settings

Use the following system settings to configure ARI database settings:

  1. In IEE, select System Administration > System Admin > System Settings.

  2. From the Section dropdown menu, select AMI Readings Import.

  3. Under the ARI Database section, configure the following settings:

    Database BCP Path

    Defines the directory path where ARI VE runners write clean reading and ancillary files. Enter a UNC path, not a local path that begins with a drive letter. If the VE runners cannot access the UNC path at the time the clean readings files are generated, the VE runners write the files to a subdirectory within the work bin folder.

    Note: This parameter applies to MS SQL Server implementations only and does not apply if the database file transfer type is FTP.

    Database File Path

    Defines the file path to the location where the binary files are placed on the database server. For FTP, use the FTP path to the AMI Readings Import directory created on the database server.

    Caution: AMI Readings Import (ARI) requires that the FTP string begin with ftp:// and include an @ symbol followed by a server address. The string must also contain at least one slash. If you do not specify a password in the Database File Path Password parameter, include the password in the database file path. Test the connection to see if you need to add the FTP location to the trusted sites list in Internet Explorer or Mozilla browsers. Do not start ARI manually before testing the connection.

    If the VE runners cannot access the UNC path at the time the clean readings files are generated, the VE runners write the files to a subdirectory within the workbin folder.

    Example file path with password:

    ftp://password:ari@ral-ora231//mnt/oraclec/files/import/

    Example file path without password:

    ftp://ari@ral-ora231//mnt/oraclec/files/import/

    Database File Path Password

    Defines the password for the FTP connection to the database. This setting is only required if the value in the Database File Transfer Type is FTP.

    Database File Size

    Defines the maximum size of the generated database file, in bytes. Enter a value of 10,240,000 (10 MB).

    Note: If the database server has many cores and available memory in relation to the number of data channels to process daily, you can reduce this file size to leverage the available processors.

    Database File Transfer Type

    Defines the file transfer method used to place ARI files on the database server. To use a third- party transfer mechanism, select Direct. The valid values are as follows:

    • FTP. Requires the Database File Path parameter to contain an FTP connection string.

    • Direct. Saves directly to an SMB-compliant network share, such as a Windows shared directory. Requires the Database File Path parameter to contain a full UNC path to the XMB-compliant share.

    Database File Type

    Defines the database file type. The valid values are as follows:

    • For Oracle, use External Table Binary (ETB).

    • For MS SQL, use Bulk Copy (BCP).

  4. Click outside of the modified field, then click Save.

Related topics: